Spreadsheet Software Test 04

Total Questions: 31

1 - Is number format in Excel consists of:

A ) 2 part
B ) 4 parts ✅
C ) 3 parts
D ) 5parts

5 - The first part of number for format describes:

A ) Positive number ✅
B ) Negative number
C ) Zero values
D ) Text values

6 - The second part of number format describes:

A ) Positive number
B ) Negative number ✅
C ) zero values
D ) Text values

7 - The third part of number format describes:

A ) Positive number
B ) Negative number
C ) Zero valus ✅
D ) Text values

8 - The fourth part of number format describes:

A ) Positive number
B ) Negative number
C ) Zero values
D ) Text values ✅

9 - The command used to merge a number of selected cells into one cell is called:

A ) Merge ✅
B ) Split
C ) Merge & Center
D ) One Unit

11 - Page orientation is changed through which dialog box?

A ) Paper
B ) Print
C ) Page setup ✅
D ) Setup

12 - Graphic representation of data is named:

A ) Graphics
B ) Picture
C ) Chart ✅
D ) Figure

13 - Which of the following is not an element of a chart:

A ) Plot area
B ) Fill handler ✅
C ) Chart area
D ) Series

14 - The vertical axis in charts is called:

A ) Z-axis
B ) Y-axis ✅
C ) X-axis
D ) Slot

15 - When the chart is created as a separate sheet, it is stored in:

A ) Current worksheet
B ) Separate work book
C ) Current work book ✅
D ) a or c

16 - Which Excel tool consists of the steps to create a chart?

A ) Graph Master
B ) Chart Wizard ✅
C ) Chart Tool
D ) Graph

17 - Which of the following is modified to add a title to chart and change title's format?

A ) Data Series
B ) Series labls
C ) Label options ✅
D ) Subtype

18 - Which tab of Format cells dialog box is used to rotate the text?

A ) Number tap
B ) Alignment tab ✅
C ) Border tap
D ) Font tab

19 - The wrap text feature is available under what mean?

A ) Edit
B ) Insert
C ) Format ✅
D ) Tools

21 - In Text orientation feature, the direction of text can be changed to:

A ) 10 degrees
B ) 45 degrees
C ) 90 degrees
D ) All

22 - The position of data in a call is called:

A ) Direction
B ) Alignment ✅
C ) Placement
D ) Position

23 - What happens if you type =A1+A2 into a worksheet call?

A ) Data amppere as a label
B ) Excel shows four Characters as number
C ) Data amppeare as a data faction
D ) Data amppears a formula ✅

24 - By default, the numbers in the cell are aligned to:

A ) Left
B ) Right ✅
C ) Bownwards
D ) Upwards

25 - By default, text in the cell is a aligned to:

A ) Left ✅
B ) Right
C ) Downwards
D ) Upwards

26 - The values given to function for calculations are called:

A ) Formulas
B ) Arguments ✅
C ) Command
D ) Syntax

27 - Which of the following is Not a type of chart?

A ) Column
B ) Pie
C ) Line
D ) Figure ✅

28 - In Excel,____are used to identify a value or a serious of values:

A ) Labels ✅
B ) Formula
C ) Values
D ) General

29 - The default number format assigned cell is:

A ) Currency
B ) Number
C ) Text
D ) General ✅

30 - A collection of reflated worksheets from a:

A ) Website
B ) Workbook ✅
C ) Spreadsheet
D ) Word Art