IT Software - Spreadsheets
This is a quiz about spreadsheets. This quiz is suitable for older children and adult learners.
- 1.
A spreadsheet is not able to:
- A.
Manage your monthly household budget
- B.
Create a graph of the number of children attending swimming lessons
- C.
Work out the cost of running a car over the course of a year
- D.
Type a letter
Correct Answer
D. Type a letter -
- 2.
Which of the following is true of Microsoft Excel:
- A.
Columns are represented by numbers
- B.
Rows are represented by letters
- C.
Columns are represented by symbols
- D.
Rows are represented by numbers
Correct Answer
D. Rows are represented by numbers -
- 3.
The boxes which make up a worksheet are known as:
- A.
Bars
- B.
Tabs
- C.
Cells
- D.
Labels
Correct Answer
C. Cells -
- 4.
You can change the way numbers in cells look by changing the formatting. Which is the following is not a numerical formatting option?
- A.
Date and time formatting
- B.
Borders and shading
- C.
Currency formatting
- D.
Percentages formatting
Correct Answer
B. Borders and shading -
- 5.
Which of the following would you include in a spreadsheet formula to multiply numbers?
- A.
*
- B.
X
- C.
/
- D.
MULTI
Correct Answer
A. * -
- 6.
Which of the following functions lets you add the value in a range of cells without having to add them one by one?
- A.
MAX
- B.
MIN
- C.
SUM
- D.
AVERAGE
Correct Answer
C. SUM -
- 7.
Which of the following does spreadsheet facilities does this describe - "use to quickly copy a cell with a formula, the formula stays the same but the cell references change as you copy across or down the worksheet"?
- A.
Autofill
- B.
Autosum
- C.
Format Painter
- D.
BODMAS
Correct Answer
A. Autofill -
- 8.
Which of the following is not a basic chart type in Microsoft Excel?
- A.
Bar
- B.
Column
- C.
Block
- D.
Line
Correct Answer
C. Block -
- 9.
Which of the following is it possible to adjust before printing a worksheet?
- A.
The print area - the part of the worksheet to be printed
- B.
The page orientation - landscape or portrait
- C.
Margins - so that more of a page can be used
- D.
All of the above
Correct Answer
D. All of the above -
Quiz Review Timeline +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Mar 20, 2022Quiz Edited by
ProProfs Editorial Team -
Jul 06, 2009Quiz Created by
Ctlcadmin
- Binary Code Quizzes
- Computer Concept Quizzes
- Computer Essential Quizzes
- Computer Forensics Quizzes
- Computer Hardware Quizzes
- Computer Networking Quizzes
- Computer Parts Quizzes
- Computer Programming Quizzes
- Computer Science Quizzes
- Computer Security Quizzes
- Computer Shortcut Key Quizzes
- Computer Skills Quizzes
- Computer Virus Quizzes
- Cyber Security Quizzes
- Data Quizzes
- Data Security Quizzes
- Hacking Quizzes
- HCI Quizzes
- Internet Quizzes
- IT SecurITy Quizzes
- Malware Quizzes
- Microprocessor Quizzes
- Network Quizzes
- Operating System Quizzes
- Phishing Quizzes
- Programming Language Quizzes
- Server Quizzes
Back to top