Question 1
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. Attaching vague hyperlinks within the spreadsheet
b. Adding alt text to charts and other images to describe their contents in words Correct
c. Using the smallest available font size
d. Using super bright and clashing colours in the spreadsheet
Question 2
It is important to consider data and structure when planning your spreadsheet.
Select one:
True Correct
False
Question 3
Conditional formatting allows Excel to automatically
highlight
cells in a particular colour based on
their
value Correct
Question 4
Which file format would you use to save an Excel file as a template?
Select one:
.xlsm
.exe
.xlsx
.xltx Correct
Question 5
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?
Find out her least successful month for shows: MIN
Calculate the total ticket sales per month: SUM
Show the current date on the spreadsheet: TODAY
Find out her most successful show week per month: MAX
Calculate the average number of ticket sales per month based on weekly sales: AVERAGE
