1. Which types of charts can excel produce ?

Line graphs and pie charts only

Only line graphs

Bar charts, line graphs and pie charts

Bar charts and line graphs only

Answer: Bar charts, line graphs and pie charts

Explanation:

Excel can produce a wide range of chart types, including (3) bar charts, line graphs, and pie charts.


2. If you press ...... the cell accepts your typing as its contents. ?

Enter

Ctrl+Enter

Tab

Insert

Answer: Enter

Explanation:

If you press option (1) Enter, the cell accepts your typing as its contents. In Excel, when you finish typing in a cell, pressing the Enter key confirms the input and moves the active cell selection down to the cell below if you're in a vertical direction or to the cell on the right if you're in a horizontal direction. The cell you were editing will display the entered content as its contents.


3. To make a number in cell C1 10% smaller than the number in C3 you enter ?

=C3 1.10

+C3*110

=C3%10

=C3*.90

Answer: =C3*.90

Explanation:

To make a number in cell C1 10% smaller than the number in C3, you would use option (4) =C3*.90. In Excel, to decrease a number by a certain percentage, you multiply the number by (1 - percentage), where the percentage is expressed as a decimal. So, to make a number 10% smaller, you multiply it by 0.90 (which is (1 - 0.10)). Therefore, the correct formula would be =C3*.90. This formula will calculate 90% of the value in cell C3, resulting in a number that is 10% smaller than the original value.


4. There are three types of data found in a spreadsheet ?

data, words, numbers

equations, data, numbers

words, numbers, labels

numbers formulas, labels

Answer: numbers formulas, labels

Explanation:

The three types of data typically found in a spreadsheet are option (4) numbers, formulas, and labels. Numbers: Spreadsheets are commonly used to store and manipulate numerical data, such as sales figures, quantities, or financial data. Formulas: Spreadsheets allow you to perform calculations and data analysis using formulas. Formulas are expressions that manipulate data, perform calculations, and generate results based on the values in other cells. Labels: Labels are used to provide descriptions or titles for data in a spreadsheet. They are typically text-based and help to identify or categorize the data in the spreadsheet. Therefore, the correct answer is option (4) numbers, formulas, and labels.


5. To open the Format Cells dialog box, press ?

Alt + 1

Ctrl + 1

Ctrl + Shift + 1

F1

Answer: Ctrl + 1

Explanation:

The correct answer is option (2) Ctrl + 1. To open the Format Cells dialog box in Microsoft Excel, you can press the keyboard shortcut Ctrl + 1. This shortcut opens the Format Cells dialog box, which allows you to modify various formatting options for the selected cells or objects. The Format Cells dialog box provides options to customize the number format, font, alignment, border, fill, and other formatting settings in Excel. Therefore, the correct answer is option (2) Ctrl + 1.


6. You can copy data or formulas ?

With the copy, paste and cut commands on the edit menu

With commands on ta short-cut menu

With buttons on the standard toolbars

All of the above

Answer: All of the above

Explanation:

You can copy data or formulas in Excel using (4) All of the above methods. Excel provides multiple ways to copy data or formulas: With the copy, paste, and cut commands on the Edit menu: You can select the desired data or formulas, click on the Edit menu, and use the Copy, Paste, or Cut commands to duplicate or move the selected content. With commands on a shortcut menu: When you right-click on a selected cell or range, a shortcut menu appears. This menu contains options such as Copy, Paste, and Cut, which allow you to perform the respective actions on the selected content. With buttons on the standard toolbars: Excel includes standard toolbars with various buttons for common operations. The standard toolbars typically have buttons for Copy, Paste, and Cut, allowing you to click on these buttons to perform the corresponding actions. Using any of these methods, you can copy data or formulas within a worksheet, between worksheets, or even between different Excel files. So, the correct option is (4) All of the above.


7. Gridlines ?

May be turned off for display but turned on for printing

May be turned on or off for printing

The be turned off for display and printing

a, b and c

Answer: a, b and c

Explanation:

Gridlines in Excel can be (4) turned off for display but turned on for printing, turned on or off for printing, and turned off for display and printing.


8. In MS-Access, a table can have primary key /keys ?

One

Two

Three

Four

Answer: One

Explanation:

The correct answer is (1) One. In Microsoft Access, a table can have one primary key. A primary key is a unique identifier for each record in a table. It ensures that each record in the table is uniquely identified and provides a way to access and manipulate data in the table. The primary key can be composed of one or more fields in the table, but there can only be one primary key per table.


9. Macros are "run" or executed from the ...... menu ?

Insert

Frmat

Tools

Data

Answer: Tools

Explanation:

Macros are "run" or executed from the (3) Tools menu. In Microsoft Excel, macros are small programs or scripts that automate tasks by performing a series of actions. To run a macro, you can access the Macros feature from the Tools menu.


10. Auto Calculate will quickly add selected cells if you ....... ?

right click on the status bar and select Sum

click the AutoCalculate button on the toolbar

use the key combination Ctrl+$

Double click the selection

Answer: click the AutoCalculate button on the toolbar

Explanation:

Auto Calculate will quickly add selected cells if you option (2) click the AutoCalculate button on the toolbar. In Excel, the AutoCalculate feature allows you to quickly perform basic calculations on a selected range of cells without entering a formula. The AutoCalculate button is located on the toolbar, typically in the status bar area. By selecting the cells you want to add and then clicking the AutoCalculate button, Excel will automatically display the sum of the selected cells in the status bar.