Which of the following formulas will Excel Not be able to calculate?
Answer: A
Correct answer: =SUM(Sales)-A3
Sales is a name, and unless it has been defined the formula has nothing to sum, so Excel returns #NAME?. The others all compute - even the division by zero, which computes an error value rather than failing to be evaluated.
Please log in or register to report this question.
A typical worksheet has …. Number of columns
Answer: B
Correct answer: 256
A worksheet in Excel up to 2003 has 256 columns, A to IV. Excel 2007 raised it to 16,384.
Please log in or register to report this question.
How many characters can be typed in a single cell in Excel?
Answer: D
Correct answer: 32,000
A cell holds up to 32,767 characters of text, of which about a thousand are displayed unless the row is enlarged. Of the figures offered, 32,000 is the one that reflects it.
Please log in or register to report this question.
A worksheet can have a maximum of …. Number of rows
Answer: D
Correct answer: 65,535
A worksheet up to Excel 2003 has 65,536 rows, that is 216, numbered 1 to 65,536. Excel 2007 raised it to 1,048,576.
Please log in or register to report this question.
Which of the following is not an example of a value?
Answer: D
Correct answer: Serial Number 50771
A value is something Excel can compute with, and a number, a date and a percentage all qualify. Serial Number 50771 begins with letters, so the whole entry is text - a label rather than a value.
Please log in or register to report this question.
The chart wizard term data series refers to
Answer: B
Correct answer: A collection of chart data markers
A data series is one row or column of values, drawn as a set of markers of the same colour - one line, or one set of bars. The legend names the series rather than being one.
Please log in or register to report this question.
The Chart wizard term data categories refers to;
Answer: B
Correct answer: A horizontal axis
Categories are plotted along the horizontal axis - the months, products or regions the values are grouped by. The values themselves go up the vertical axis.
Please log in or register to report this question.
A worksheet range is a
Answer: C
Correct answer: A group of cells
A range is a rectangular block of cells, written as its two opposite corners: B2:D10.
Please log in or register to report this question.
Getting data from a cell located in a different sheet is called …
Answer: B
Correct answer: Referencing
Using a value from another sheet is referencing it, written with the sheet name and an exclamation mark: =Sheet2!A1.
Please log in or register to report this question.
Tab scrolling button
Answer: D
Correct answer: Allow you to view additional sheets tabs
The four small arrows at the left of the sheet tabs scroll the tabs when there are more sheets than fit. They change which tabs are visible, not which sheet is active.
Please log in or register to report this question.
