Revision test -Spreadsheet

Which of the following cell address is known as absolute

• $K4$

• K$4$

• $K$4

• K4$

The cell address in a formula is called as

• Cell Reference
• Cell Number
• Cell Location
• Cell Position

The function that is used to find the total value of the range of cells

• SUM
• AVERAGE
• COUNT
• MIN

The pictorial representation of data is known as

• Histogram
• Graph
• Pie Chart
• All of the above

Functions in excel are basically known as

• Formulas
• Cells
• Spreadsheets
• Tables

How many females liked vanilla flavor?

• 10 females
• 20 females
• 30 females
• 40 females

GPRS stands for

• General Packet Radio Service
• Global Public Radio Service
• General Public Radio System
• Global Packet Radio System

The default cell in excel sheet

• A1
• B2
• C3
• D4

When corresponding cell address changes with reference to a new cell address it is known as ___________ reference

• absolute

• mixed

• relative

• circular

Which of the options show least percentage

• business

• Sight seing

• outdoor recreation

• Visit friends and relatives