Quiz
Untitled
Questions in this quiz (3)
1The following function highlighted in yellow should lookup "Orange" in the fruit column and return the value of Stock left. However, it is currently returning an error due to a flawed logic in the formula. What is the flaw?
- AThe Vlookup range should be "True" instead of "False"
- BThe variable "Fruit" should be column A instead of column B
- CThe "3" in the formula should actually be "2" to look up the value in the "Fruit" column
- DThe "3" in the formula should actually be "C" to represent the column it is returning the variable from
2When printing the following spreadsheet, only the highlighted range prints, but column "C" won't print. Why is that?
- AThe margins and dimensions need to be set to print the rest of the document
- BThe rest of the spreadsheet must be highlighted to have all print area selected
- CThe print area is not set up properly to print the rest of the sheet
- DThe printer driver is set up incorrectly
3The after-tax cost of my project is $1,800 and that we charged HST to the client. What was the pre-tax amount?
- A1,800 x (1-0.13)
- B1800/(100+13)x100
- C1800/(0.13)/10
Information
- Description
- Quiz on Untitled, created by Rachel Chu on 19/04/2017.
- Author
- Rachel Chu
- Language
- English
- Views
- 0
- Rating
- No ratings yet Rate this quiz