Qiz 2

docx

School

Monarch Institute *

*We aren’t endorsed by this school

Course

BSBTEC402

Subject

Industrial Engineering

Date

Feb 20, 2024

Type

docx

Pages

Uploaded by ProfTapir2943

Feedback This is a very good result. You have shown an in-depth understanding of this m an excellent result. Well done. Question 1 Correct Mark 1.00 out of 1.00 Flag question Question text Charles just employed Glory, who has a vision impairment and uses a screen reader, as part of the Angel's Share bar staff. Which options would be most helpful for Charles to make his spreadsheets accessible to Glory? Select one: a. Using the smallest available font size b. Using super bright and clashing colours in the spreadsheet c. Adding alt text to charts and other images to describe their contents in words Correct d. Attaching vague hyperlinks within the spreadsheet Feedback Your answer is correct. Question 2 Correct Mark 1.00 out of 1.00 Flag question Question text It is important to consider data and structure when planning your spreadsheet. Select one: True Correct False Question 3 Correct Mark 2.00 out of 2.00

Flag question Question text Conditional formatting allows Excel to automatically blank Correct cells in a particular colour based on their blank Correct. highlightvalue Feedback Your answer is correct. Question 4 Correct Mark 1.00 out of 1.00 Flag question Question text Which file format would you use to save an Excel file as a template? Select one: .xltx Correct .exe .xlsm .xlsx Feedback Your answer is correct. Question 5 Correct Mark 5.00 out of 5.00 Flag question

Question text Tracy wants a quick overview of her ticket sales for her weekly magic shows for the past year. Which functions could she use for the following tasks? Show the current date on the spreadsheet Answer 1 Correct Calculate the total ticket sales per month Answer 2 Correct Find out her most successful show week per month Answer 3 Correct Calculate the average number of ticket sales per month based on weekly sales Answer 4 Correct Find out her least successful month for shows Answer 5 Correct Feedback Your answer is correct. TODAY SUM MAX AVERAGE MIN

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

Qiz 2

Related Documents