Computer Applications Quiz: Excel Unit A
It covers information covered in Excel unit a, as well as some Questions from MS Word and Computer Concepts
Questions and Answers
- 1.
What is the difference between a Work Book and a Work Sheet
- A.
Work Book is Excell, and Work Sheet is MicroSoft Word
- B.
Work book 255 different books within one Worksheet
- C.
There is no difference
- D.
A work book is a file that holds up to 255 worksheets, a work sheet is a data sheet that allows the organize and manipulate data
- E.
What is a Work book for 200?, Alex
Correct Answer
D. A work book is a file that holds up to 255 worksheets, a work sheet is a data sheet that allows the organize and manipulate dataExplanation
A work book is a file that holds up to 255 worksheets, while a work sheet is a data sheet that allows the organization and manipulation of data.Rate this question:
-
- 2.
In Excel, order of precedence determines:
- A.
The order in which worksheets are printed.
- B.
The colors used to distinguish cell references.
- C.
The order in which calculations are performed.
- D.
How values are multiplied.
Correct Answer
C. The order in which calculations are performed.Explanation
The order of precedence in Excel refers to the hierarchy in which mathematical operations are performed in a formula. It determines the sequence in which calculations are executed, ensuring that the correct result is obtained. This is important because different operations have different priorities, and Excel follows a specific set of rules to determine the order in which calculations should be carried out. By understanding the order of precedence, users can accurately perform complex calculations and obtain the desired outcome.Rate this question:
-
- 3.
The maximum number of worksheets you can include in a workbook is:
- A.
3
- B.
250
- C.
255
- D.
Unlimited
Correct Answer
C. 255Explanation
The maximum number of worksheets you can include in a workbook is 255. This means that you can have up to 255 separate sheets within a single workbook file. This allows for a large amount of organization and data storage within a single file, making it easier to manage and navigate through multiple sets of data.Rate this question:
-
- 4.
A selction of multiple cells is called a:
- A.
Group
- B.
Range
- C.
Reference
- D.
Package
Correct Answer
B. RangeExplanation
A selection of multiple cells in a spreadsheet is called a range. A range refers to a group of adjacent cells that are selected together for performing operations or applying formatting. It allows for efficient manipulation of data and performing calculations across multiple cells simultaneously.Rate this question:
-
- 5.
Using a cell address in a formula is known as:
- A.
Formularizing
- B.
Prefixing
- C.
Cell referencing
- D.
Cell mathematics
Correct Answer
D. Cell mathematics -
- 6.
Which worksheet view shows how your worksheet will look when printed?
- A.
Page layout
- B.
Data
- C.
Review
- D.
View
Correct Answer
A. Page layoutExplanation
The Page Layout view in a worksheet shows how the worksheet will appear when printed. It allows users to see the exact placement of data, headers, footers, and other elements on the printed page. This view is useful for adjusting the layout and formatting of the worksheet to ensure it fits properly on the printed page and looks as intended.Rate this question:
-
- 7.
Which button should you click if you want to print formulas in a worksheet?
- A.
Save button
- B.
Fill button
- C.
Any button on the Quick Access Toolbar
- D.
Office button
Correct Answer
D. Office buttonExplanation
The Office button is the correct answer because it is the button that provides access to various commands and options in Microsoft Office applications, including the option to print formulas in a worksheet. By clicking on the Office button, users can access the Print menu and choose to print the formulas along with the rest of the worksheet content.Rate this question:
-
- 8.
Clicking the Scale arrow in the Scale to Fit group on the Page Layout tab opens which dialog box
- A.
Print
- B.
Scale to fit
- C.
Width/Height
- D.
Page setup
Correct Answer
D. Page setupExplanation
Clicking the Scale arrow in the Scale to Fit group on the Page Layout tab opens the Page Setup dialog box. This dialog box allows the user to customize various settings related to the page layout, such as paper size, orientation, margins, and scaling options. By clicking the Scale arrow, the user can access the scaling options within the Page Setup dialog box, which allows them to adjust the size of the content to fit within the specified page dimensions.Rate this question:
-
- 9.
In which view can you see the header and footer areas of a worksheet?
- A.
Normal view
- B.
Page layout view
- C.
Page break preview
- D.
Header/Footer
Correct Answer
B. Page layout viewExplanation
In Page layout view, you can see the header and footer areas of a worksheet. This view displays the worksheet as it would appear when printed, including the header and footer sections. It allows you to easily customize and edit the header and footer content, such as adding page numbers, dates, or titles. This view is helpful for previewing and adjusting the layout of the worksheet before printing.Rate this question:
-
- 10.
Which key can you press to switch to edit mode?
- A.
[F1]
- B.
[F2]
- C.
[F4]
- D.
[F6]
Correct Answer
B. [F2]Explanation
Pressing the [F2] key allows you to switch to edit mode.Rate this question:
-
- 11.
Which type of break can you insert if you want to force text to begin on the next page?
- A.
Automatic page break
- B.
Continuous section break
- C.
Text wrapping break
- D.
Next page section break
Correct Answer
D. Next page section breakExplanation
A "Next page section break" can be inserted to force text to begin on the next page. This type of break creates a new section and starts the content on a new page, ensuring that the text following the break will always begin on a fresh page.Rate this question:
-
- 12.
Which type of break do you insert if you want to balance the columns in a section?
- A.
Column break
- B.
Continuous section break
- C.
Manual page break
- D.
Text wrapping break
Correct Answer
B. Continuous section breakExplanation
A continuous section break is used to balance the columns in a section. This type of break allows for the content to flow smoothly from one column to another, ensuring that the columns are evenly distributed. It is commonly used in documents with multiple columns, such as newsletters or magazines, to create a visually appealing layout.Rate this question:
-
- 13.
Which of the following cannot be inserted using the Quick Parts command?
- A.
AutoText building block
- B.
Document property
- C.
Page number field
- D.
Page break
Correct Answer
D. Page breakExplanation
The Quick Parts command in Microsoft Word allows users to insert pre-defined content into their documents. AutoText building blocks, document properties, and page number fields are all examples of content that can be inserted using the Quick Parts command. However, a page break is not a type of content that can be inserted using this command. Instead, page breaks are inserted using the Page Layout tab or by pressing Ctrl+Enter on the keyboard.Rate this question:
-
- 14.
Which of the following do documents with mirror margins always have?
- A.
Gutters
- B.
Landscape orientation
- C.
Inside and outside margins
- D.
Different first page headers and footers
Correct Answer
C. Inside and outside marginsExplanation
Documents with mirror margins always have inside and outside margins. Mirror margins are a type of layout where the inside and outside margins of a document are different. The inside margin is wider than the outside margin, allowing for binding or folding of the document. This layout is commonly used for documents that will be printed and bound, such as books or brochures, to ensure that the text is evenly distributed on each page and does not get cut off during the binding process.Rate this question:
-
- 15.
What name describes formatted pieces of content that are stored in galleries?
- A.
Header
- B.
Field
- C.
Building block
- D.
Property
Correct Answer
C. Building blockExplanation
Building block is the correct answer because it accurately describes formatted pieces of content that are stored in galleries. Building blocks are pre-designed content elements that can be easily inserted into documents or templates. They can include text, images, tables, or other types of content, and they provide a convenient way to reuse and manage content in a structured manner. By organizing content into building blocks, users can quickly access and insert commonly used elements, saving time and ensuring consistency in their documents.Rate this question:
-
- 16.
What must you do to change an inline graphic to a floating graphic?
- A.
Apply text wrapping to the graphic
- B.
Resize the graphic
- C.
Anchor the graphic
- D.
Move the graphic
Correct Answer
A. Apply text wrapping to the graphicExplanation
To change an inline graphic to a floating graphic, you need to apply text wrapping to the graphic. This allows the graphic to be moved independently from the surrounding text, giving it a floating effect. By applying text wrapping, you can position the graphic anywhere on the page and have the text flow around it. This is useful when you want to have more control over the placement of the graphic in your document.Rate this question:
-
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 28, 2023Quiz Edited by
ProProfs Editorial Team -
Oct 20, 2009Quiz Created by
Mr.rumsey
- 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
- Programming Language Quizzes
- Software Quizzes
Back to top