Ms excel

1. Which setting you must modify to print a worksheet using letterhead? A. Paper B. Margin C. Layout D. Orientation

Paper
Margin
Layout
Orientation

Detailed SolutionWhich setting you must modify

Join Our Telegram Channel
d="M549.7 124.1c-6.3-23.7-24.8-42.3-48.3-48.6C458.8 64 288 64 288 64S117.2 64 74.6 75.5c-23.5 6.3-42 24.9-48.3 48.6-11.4 42.9-11.4 132.3-11.4 132.3s0 89.4 11.4 132.3c6.3 23.7 24.8 41.5 48.3 47.8C117.2 448 288 448 288 448s170.8 0 213.4-11.5c23.5-6.3 42-24.2 48.3-47.8 11.4-42.9 11.4-132.3 11.4-132.3s0-89.4-11.4-132.3zm-317.5 213.5V175.2l142.7 81.2-142.7 81.2z"/> Subscribe on YouTube
to print a worksheet using letterhead? A. Paper B. Margin C. Layout D. Orientation

2. Which would you choose to create a bar diagram? A. Edit, Chart B. Insert, Chart C. Tools, Chart D. Format, Chart

Edit, Chart
Insert, Chart
Tools, Chart
Format, Chart

Subscribe on YouTube

Join Our Telegram Channel
Chart D. Format, Chart" class="read-more button" href="https://exam.pscnotes.com/mcq/which-would-you-choose-to-create-a-bar-diagram-a-edit-chart-b-insert-chart-c-tools-chart-d-format-chart/#more-14672">Detailed SolutionWhich would you choose to create a bar diagram? A. Edit, Chart B. Insert, Chart C. Tools, Chart D. Format, Chart

3. How many worksheets can a workbook have? A. 3 B. 8 C. 255 D. none of above

3
8
255
none of above

Detailed SolutionHow many worksheets can

Join Our Telegram Channel
0 213.4-11.5c23.5-6.3 42-24.2 48.3-47.8 11.4-42.9 11.4-132.3 11.4-132.3s0-89.4-11.4-132.3zm-317.5 213.5V175.2l142.7 81.2-142.7 81.2z"/> Subscribe on YouTube
a workbook have? A. 3 B. 8 C. 255 D. none of above

4. Which of the following is not a term of MS-Excel? A. Cells B. Rows C. Columns D. Document

Cells
Rows
Columns
Document

Detailed SolutionWhich of

Join Our Telegram Channel
Subscribe on YouTube
the following is not a term of MS-Excel? A. Cells B. Rows C. Columns D. Document

5. Which language is used to create macros in Excel? A. Visual Basic B. C C. Visual C++ D. Java

Visual Basic
C
Visual C++
Java

Join Our Telegram Channel

576 512"> Subscribe on YouTube C. Visual C++ D. Java" class="read-more button" href="https://exam.pscnotes.com/mcq/which-language-is-used-to-create-macros-in-excel-a-visual-basic-b-c-c-visual-c-d-java/#more-14669">Detailed SolutionWhich language is used to create macros in Excel? A. Visual Basic B. C C. Visual C++ D. Java

6. What is the correct way to refer the cell A10 on sheet3 from sheet1? A. Sheet3!A10 B. Sheet1!A10 C. Sheet3.A10 D. A10

Sheet3!A10
Sheet1!A10
Sheet3.A10
A10

Join Our Telegram Channel
Subscribe on YouTube
Sheet3.A10 D. A10" class="read-more button" href="https://exam.pscnotes.com/mcq/what-is-the-correct-way-to-refer-the-cell-a10-on-sheet3-from-sheet1-a-sheet3a10-b-sheet1a10-c-sheet3-a10-d-a10/#more-14668">Detailed SolutionWhat is the correct way to refer the cell A10 on sheet3 from sheet1? A. Sheet3!A10 B. Sheet1!A10 C. Sheet3.A10 D. A10

7. Excel displays the current cell address in the ________ A. Formula bar B. Status Bar C. Name Box D. Title Bar

Formula bar
Status Bar
Name Box
Title Bar

Join Our Telegram Channel

viewBox="0 0 576 512"> Subscribe on YouTube Title Bar" class="read-more button" href="https://exam.pscnotes.com/mcq/excel-displays-the-current-cell-address-in-the-________-a-formula-bar-b-status-bar-c-name-box-d-title-bar/#more-14667">Detailed SolutionExcel displays the current cell address in the ________ A. Formula bar B. Status Bar C. Name Box D. Title Bar

8. What is the short cut key to highlight the entire column? A. Ctrl + C B. Ctrl + Enter C. Ctrl + Page Up D. Ctrl + Space Bar

Ctrl + C
Ctrl + Enter
Ctrl + Page Up
Ctrl + Space Bar

Detailed SolutionWhat is the short cut key to highlight the entire column? A. Ctrl + C B. Ctrl + Enter

Join Our Telegram Channel
Subscribe on YouTube
C. Ctrl + Page Up D. Ctrl + Space Bar

9. In the formula, which symbol specifies the fixed columns or rows? A. $ B. * C. % D. &

$
*
%
&

Detailed SolutionIn the formula, which symbol specifies the fixed columns

Join Our Telegram Channel
Subscribe on YouTube
or rows? A. $ B. * C. % D. &

10. What does COUNTA () function do? A. Counts cells having alphabets B. Counts empty cells C. Counts cells having number D. Counts non-empty cells

Counts cells having alphabets
Counts empty cells
Counts cells having number
Counts non-empty cells

Join Our Telegram Channel

48.3 47.8C117.2 448 288 448 288 448s170.8 0 213.4-11.5c23.5-6.3 42-24.2 48.3-47.8 11.4-42.9 11.4-132.3 11.4-132.3s0-89.4-11.4-132.3zm-317.5 213.5V175.2l142.7 81.2-142.7 81.2z"/> Subscribe on YouTube having alphabets B. Counts empty cells C. Counts cells having number D. Counts non-empty cells" class="read-more button" href="https://exam.pscnotes.com/mcq/what-does-counta-function-do-a-counts-cells-having-alphabets-b-counts-empty-cells-c-counts-cells-having-number-d-counts-non-empty-cells/#more-14664">Detailed SolutionWhat does COUNTA () function do? A. Counts cells having alphabets B. Counts empty cells C. Counts cells having number D. Counts non-empty cells

Page 1Page 2Page 3Page 4Page 5
Test 1Test 2Test 3