Except for the …… function, a formula with a logical function shows the word “TRUE” or “FALSE” as a result
Answer: A
Correct answer: IF
AND, OR and NOT return TRUE or FALSE and nothing else. IF tests a condition and then returns whichever of two values it is given, so its result can be anything at all.
Please log in or register to report this question.
Macros are “run” or executed from the ….. menu.
Answer: C
Correct answer: Tools
Macros are recorded, run and edited from Tools > Macro.
Please log in or register to report this question.
You can open the Consolidate dialog box by choosing Consolidate from the ..... menu.
Answer: D
Correct answer: Data
Consolidate combines figures from several ranges or sheets into one summary, which makes it a data command.
Please log in or register to report this question.
Each excel file is called a workbook because
Answer: C
Correct answer: It can contain many sheets including worksheets and chart sheets
A workbook is a book of sheets: several worksheets and chart sheets held in one file, able to refer to each other's cells.
Please log in or register to report this question.
Which types of charts can excel produce?
Answer: C
Correct answer: Bar charts, line graphs and pie charts
Excel produces all the common chart types - column and bar, line, pie, scatter, area, doughnut, radar and more - so any option restricting it to one or two is wrong.
Please log in or register to report this question.
How are data organized in a spreadsheet?
Answer: C
Correct answer: Rows and columns
A spreadsheet is a grid of numbered rows and lettered columns, and a cell is identified by the intersection of the two.
Please log in or register to report this question.
What does the VLOOKUP function do?
Answer: C
Correct answer: Finds related records
VLOOKUP searches the first column of a table for a value and returns something from the same row of another column - which is how one record is matched to another. The V is for vertical, not for the letter looked up.
Please log in or register to report this question.
Gridlines
Answer: D
Correct answer: a, b and c
Display and printing are controlled separately: gridlines may be shown on screen but not printed, printed but not shown, or neither. All three statements are therefore true.
Please log in or register to report this question.
You can print only an embedded chart by
Answer: D
Correct answer: a and c
An embedded chart prints on its own either by being moved to a chart sheet first, or simply by being selected before printing - selecting it makes it the print range. Formatting has no bearing on what is printed.
Please log in or register to report this question.
Which of the following is a correct order of precedence in a formula calculation?
Answer: D
Correct answer: None of above
The true order is: negation, then percent, then exponentiation, then multiplication and division, then addition and subtraction, then comparison. Each of the three orders offered puts at least one of these in the wrong place.
Please log in or register to report this question.
