IT Software - Spreadsheets - Quiz, Flashcards & Trivia

1. A spreadsheet is not able to:

Manage your monthly household budget

Create a graph of the number of children attending swimming lessons

Work out the cost of running a car over the course of a year

Type a letter

2. The boxes which make up a worksheet are known as:

Bars

Tabs

Cells

Labels

3. Which of the following functions lets you add the value in a range of cells without having to add them one by one?

MAX

MIN

SUM

AVERAGE

4. Which of the following is it possible to adjust before printing a worksheet?

The print area - the part of the worksheet to be printed

The page orientation - landscape or portrait

Margins - so that more of a page can be used

All of the above

5. Which of the following is true of Microsoft Excel:

Columns are represented by numbers

Rows are represented by letters

Columns are represented by symbols

Rows are represented by numbers

6. You can change the way numbers in cells look by changing the formatting. Which is the following is not a numerical formatting option?

Date and time formatting

Borders and shading

Currency formatting

Percentages formatting

7. Which of the following would you include in a spreadsheet formula to multiply numbers?

*

X

/

MULTI

8. Which of the following is not a basic chart type in Microsoft Excel?

Bar

Column

Block

Line

9. 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"?

Autofill

Autosum

Format Painter

BODMAS

IT Software - Spreadsheets