For selecting the entire worksheet in Excel, you need to press ………………. -Technology

For selecting the entire worksheet in Excel, you need to press ………………. -Technology
by

1 Answer

Answer :

(b) You need to press Ctrl + Shift + Spacebar for selecting the entire worksheet in Excel.
by

Related questions

The sample of an Excel worksheet on the screen can be seen by ……………….. -Technology

Description : The sample of an Excel worksheet on the screen can be seen by ……………….. -Technology

Last Answer : (a) Print preview enables you to view the sample of worksheet before printing it on a paper.

How can I pull data from one Excel worksheet to another based on matching Part Number?

Description : How can I pull data from one Excel worksheet to another based on matching Part Number?

Last Answer : answer:The Vlookup function is what you seek. Example: Book1 has a list of part numbers 1 2 3 4 5 Book2 has a list of part numbers,with product name 4 tchotchke 2 gizmo 5 trinket 3 thingy 1 doodad ... have to be in any particular order on either sheet. (if you use that FALSE argument at the end).

What kind of documentation is allowed by MS - Excel default worksheet ( .xls) ?

Description : What kind of documentation is allowed by MS - Excel default worksheet ( .xls) ?

Last Answer : MS-Excel allows creation of Worksheet (.xls) documents by default worksheet ( .xls ).

In an Excel worksheet does a column typically contain information that is similar to a list?

Description : In an Excel worksheet does a column typically contain information that is similar to a list?

Last Answer : Yes it does, like a field in a database.

The basic unit ofa worksheet into which you enter data in Excel is called a– (A) tab (B) cell (C) box (D) range (E) None of these

Description : The basic unit ofa worksheet into which you enter data in Excel is called a– (A) tab (B) cell (C) box (D) range (E) None of these

Last Answer : cell

Ctrl + Page up (In Ms - Excel) is used for: a) Move to the previous worksheet in the workbook b) Insert a new worksheet into the current workbook c) Select the current worksheet and the next worksheet d) None of These

Description : Ctrl + Page up (In Ms - Excel) is used for: a) Move to the previous worksheet in the workbook b) Insert a new worksheet into the current workbook c) Select the current worksheet and the next worksheet d) None of These

Last Answer : a) Move to the previous worksheet in the workbook

In MS - Excel, Move to the next worksheet in the workbook can be done through: a) Ctrl + Page Down b) Ctrl + Page Up c) Ctrl + F3 d) None of These

Description : In MS - Excel, Move to the next worksheet in the workbook can be done through: a) Ctrl + Page Down b) Ctrl + Page Up c) Ctrl + F3 d) None of These

Last Answer : a) Ctrl + Page Down

The basic unit of a worksheet into which you enter data in excel is called a ______: a) Tab b) Cell c) Box d) Range e) None of The Above

Description : The basic unit of a worksheet into which you enter data in excel is called a ______: a) Tab b) Cell c) Box d) Range e) None of The Above

Last Answer : b) Cell

In MS-Excel, ______ provide a visual representation of the values in a worksheet. (1) Charts (2) Formulae (3) Templates (4) Views

Description : In MS-Excel, ______ provide a visual representation of the values in a worksheet. (1) Charts (2) Formulae (3) Templates (4) Views

Last Answer : Charts

What is the difference between a workbook and a worksheet? -Technology

Description : What is the difference between a workbook and a worksheet? -Technology

Last Answer : Differences between the workbook and worksheet are as follows:WorkbookWorksheetA workbook is an Excel file with one ormore worksheets.A worksheet is a single spreadsheet of data.A workbook would be the entire binder,with everything in it.A worksheet would be like one section inthat binder.

Is it possible to remove a worksheet? State the process of doing it. -Technology

Description : Is it possible to remove a worksheet? State the process of doing it. -Technology

Last Answer : Yes, it is possible to remove a worksheet. To remove a worksheet right-click on the Sheets tab of the sheet that you want to delete and choose Delete from the popup menu, or choose Delete Sheet from the pop-up menu of Delete option on cells group under Home tab.

Explain any five functions that can be used in a worksheet. -Technology

Description : Explain any five functions that can be used in a worksheet. -Technology

Last Answer : 1. SUM FunctionThis function, as clear from the name, is used to add all the values provided as an argument and to display the result in the cell containing the function.Argument Type All ... 0 (zero).Arguments that are error values or text that cannot be translated into numbers cause errors.

Sana has entered 49+30 in a cell. The worksheet is not displaying 79 in the cell. -Technology

Description : Sana has entered 49+30 in a cell. The worksheet is not displaying 79 in the cell. -Technology

Last Answer : In Excel, every formula must start with a = (equal) sign.Since Sana has not put = sign before 49+30, thus she is not able to see the desired result will be displayed if she will use = (49 + 30) formula.

In a worksheet, cell K12 has a value. A formula is to be entered in cell K15, such that if the value in cell K12 -Technology

Description : In a worksheet, cell K12 has a value. A formula is to be entered in cell K15, such that if the value in cell K12 -Technology

Last Answer : In cell K15, enter the conditional statement as: = IF (K12 > 300, K12 *1.33, K12 * 1.5). Here, IF condition checks the value at K12, that is, if it is greater than 300, then calculate 1.33 of K12, otherwise 1.5 of K12.

A worksheet is a ………………. (a) collection of workbooks -Technology

Description : A worksheet is a ………………. (a) collection of workbooks -Technology

Last Answer : (c) A worksheet is a combination of rows and columns.

A chart is a graphical representation of worksheet data. -Technology

Description : A chart is a graphical representation of worksheet data. -Technology

Last Answer : True A chart is a graphical representation of worksheet data.

Which of the following can you print: a) A range of cells by range name b) An entire worksheet c) A single worksheet d) None of The Above

Description : Which of the following can you print: a) A range of cells by range name b) An entire worksheet c) A single worksheet d) None of The Above

Last Answer : c) A single worksheet

To select slides at discrete order in the Slides Pane you need hold the ………………. on the keyboard while selecting the slides. -Technology

Description : To select slides at discrete order in the Slides Pane you need hold the ………………. on the keyboard while selecting the slides. -Technology

Last Answer : To select slides at discrete order in the Slides Pane you need hold the Ctrl keyon the keyboard while selecting the slides.

For selecting a non_continuous range of cells, you need to do what? -Technology

Description : For selecting a non_continuous range of cells, you need to do what? -Technology

Last Answer : (d) By pressing Ctrl key and clicking on the desired cells a non-continuous cell range can be selected

An application can be opened through shortcut on the desktop by (a) Double clicking on its shortcut (b) Selecting the icon and pressing Enter -Technology

Description : An application can be opened through shortcut on the desktop by (a) Double clicking on its shortcut (b) Selecting the icon and pressing Enter -Technology

Last Answer : (d) An application can be opened through the shortcut made on desktop by double clicking on its shortcut icon, pressing Enter or Right clicking and choosing Open button.

In MS-EXCEL, for Moves the current selected range down a row, you will press: a) Shift + Up Arrow Key b) Shift + Down Arrow Key c) Ctrl + Down Arrow Key d) None of These

Description : In MS-EXCEL, for Moves the current selected range down a row, you will press: a) Shift + Up Arrow Key b) Shift + Down Arrow Key c) Ctrl + Down Arrow Key d) None of These

Last Answer : b) Shift + Down Arrow Key

In MS-EXCEL, for Moves the current selected range down a row, you will press: a) Shift + Up Arrow Key b) Shift + Down Arrow Key c) Ctrl + Down Arrow Key d) None of These

Description : In MS-EXCEL, for Moves the current selected range down a row, you will press: a) Shift + Up Arrow Key b) Shift + Down Arrow Key c) Ctrl + Down Arrow Key d) None of These

Last Answer : b) Shift + Down Arrow Key

Reena is new to Excel. Her instructor has asked her to open Excel on her PC and questioned about active cell. -Technology

Description : Reena is new to Excel. Her instructor has asked her to open Excel on her PC and questioned about active cell. -Technology

Last Answer : An active cell is a cell with heavy black color boundary.

In Excel, how many ways are there to express/format a number? -Technology

Description : In Excel, how many ways are there to express/format a number? -Technology

Last Answer : Numbers in Excel can be expressed in many different formats like date, time, percentage or decimals.

What is the use of the COUNT() function in Excel? -Technology

Description : What is the use of the COUNT() function in Excel? -Technology

Last Answer : Excel’s COUNT() function can be used to total the number of cells in a selected range. The COUNT() function will add up the number of cells in a selected range that contains numbers.

How are charts created in Excel? Write the steps. -Technology

Description : How are charts created in Excel? Write the steps. -Technology

Last Answer : Creating a Chart:Here is a worksheet that shows the marks of students in a class subject wise. To create a chart, do the following:1. Select the data that you want to show, including the ... Design tab under Chart Tools, in the Type group, click Change Chart Type and select another chart type.

By default, a workbook in Excel contains how many worksheets? -Technology

Description : By default, a workbook in Excel contains how many worksheets? -Technology

Last Answer : (b) 3 worksheets are present in every workbook by default.

The simplest way to move data from one location to another in Excel is ……………… -Technology

Description : The simplest way to move data from one location to another in Excel is ……………… -Technology

Last Answer : (d) We can move data using cut and paste and also drag and drop method is the easiest one.

The default page orientation in Excel is (a) Landscape -Technology

Description : The default page orientation in Excel is (a) Landscape -Technology

Last Answer : (c) The default page orientation in Excel is Portrait.

In Excel chart, text displayed at data points to indicate the specific category is called …………….. -Technology

Description : In Excel chart, text displayed at data points to indicate the specific category is called …………….. -Technology

Last Answer : (c) Text displayed at data points to indicate the specific category is called data label.

Excel is a ………………. software package. -Technology

Description : Excel is a ………………. software package. -Technology

Last Answer : Excel is aspreadsheetsoftware package.

Any formula in Excel starts with an …………….. -Technology

Description : Any formula in Excel starts with an …………….. -Technology

Last Answer : Any formula in Excel starts with anequal (=) sign.

If you enter 15 + 30 in a cell, Excel will display …………….. -Technology

Description : If you enter 15 + 30 in a cell, Excel will display …………….. -Technology

Last Answer : If you enter 15 + 30 in a cell, Excel will display15 + 30.

You cannot open two different workbooks in Excel simultaneously. -Technology

Description : You cannot open two different workbooks in Excel simultaneously. -Technology

Last Answer : False You can open two different workbooks in Excel simultaneously.

If the data entered in a cell is 546z then, Excel will treat it as a number because it starts with a digit. -Technology

Description : If the data entered in a cell is 546z then, Excel will treat it as a number because it starts with a digit. -Technology

Last Answer : False It will be treated as non-numeric data because it contains letters along with numbers.

What key do you use to erase an entire entry in a cell and then reenter the data from the beginning with Excel?

Description : What key do you use to erase an entire entry in a cell and then reenter the data from the beginning with Excel?

Last Answer : You can press the Delete key. However, if you just select a celland start typing, it will replace what is in the cell, so it is notnecessary to press the Delete key first.

Press and hold ……………….. of mouse while dragging for drawing a shape. -Technology

Description : Press and hold ……………….. of mouse while dragging for drawing a shape. -Technology

Last Answer : Press and holdleft buttonof mouse while dragging for drawing a shape.

Set new timing, while rehearsing ……………… key is press. (a) Ctrl+T (b) T (c) M (d) O -Technology

Description : Set new timing, while rehearsing ……………… key is press. (a) Ctrl+T (b) T (c) M (d) O -Technology

Last Answer : (b) T key is used to set new timing while rehearsing.

What were the technological factors that facilitated the growth and development of press. -Technology

Description : What were the technological factors that facilitated the growth and development of press. -Technology

Last Answer : The main technologies that facilitated the development of large-scale printing and distribution of print material were the printing press, the telegraph and the railways. The industrial revolution and the ... the public sphere provided the impetus and the support for rapid developments in the press.

A Press Sorting Office is: (A) A RMS Office where the articles received from the various Presses and publishers are only sorted (B) A RMS office situated on the premises of a newspaper publisher (C) (B) above, plus where the articles received from the newspaper publisher is sorted and despatched and where the entire expenditure of the establishment of the office is borne by the newspaper publisher (D) A branch of a Sorting Mail Office dealing with articles from Press / Publishers and Registered newspapers

Description : A Press Sorting Office is: (A) A RMS Office where the articles received from the various Presses and publishers are only sorted (B) A RMS office situated on the premises of a newspaper ... ) A branch of a Sorting Mail Office dealing with articles from Press / Publishers and Registered newspapers

Last Answer : (C) (B) above, plus where the articles received from the newspaper publisher is sorted and despatched and where the entire expenditure of the establishment of the office is borne by the newspaper publisher

Selecting a correct DC stepper motor for a project?

Description : Selecting a correct DC stepper motor for a project?

Last Answer : You will need to calculate the moment of inertia of the shaft you are turning so you can determine the required torque. You will get that after you determine the peak acceleration from the velocity ... Once you have acceleration, displacement, and moment of inertia you can size the motor for power.

The entire Word document can be printed by choosing Microsoft Office button —> Print and OK. -Technology

Description : The entire Word document can be printed by choosing Microsoft Office button —> Print and OK. -Technology

Last Answer : TrueSteps for printing the document is Microsoft Office button —> Print and OK.

A worm is a self_replicating program which eats up the entire disk space. -Technology

Description : A worm is a self_replicating program which eats up the entire disk space. -Technology

Last Answer : False Virus eats up the entire disk space.

The entire presentation can be seen at a time in ………………. (a) Slide Show view (b) Outline view (c) Normal view (d) Slide Sorter view -Technology

Description : The entire presentation can be seen at a time in ………………. (a) Slide Show view (b) Outline view (c) Normal view (d) Slide Sorter view -Technology

Last Answer : (d) Slide Sorter view enables you to view the entire presentation at a time

What is quota sampling? Do you agree that the quota sampling is more reflective of the entire group? -Technology

Description : What is quota sampling? Do you agree that the quota sampling is more reflective of the entire group? -Technology

Last Answer : Quota sampling is a method for selecting survey participants. In quota sampling, a population is first segmented into mutually exclusive sub-groups. Then judgment is used to select the subjects or units from each segment based on a specified proportion.' {Rest of the answer is subjective}

Help! I'm trying to write something in an excel spreadsheet and it's showing up below as well...

Description : Help! I'm trying to write something in an excel spreadsheet and it's showing up below as well...

Last Answer : answer:Okay, my answer is gonna get moderated, but this drives me nuts. Every company I've ever worked at, managers all want to use Excel as if it was a word processor. Excel is not a word processor! ... column to become wide), or causing the text to continue to the into the next cell to the right.

Is it possible to prevent someone from copying the cell from your worksheet?

Description : Is it possible to prevent someone from copying the cell from your worksheet?

Last Answer : There are several ways to prevent someone from copying cells from your worksheet, depending on the specific software and platform you are using. Some of the most common methods include: Password ... foolproof and determined individuals may still be able to copy the data by using other methods.

The intersection of a worksheet column and row is a?

Description : The intersection of a worksheet column and row is a?

Last Answer : a "spread"

where can i find a sequence worksheet?

Description : where can i find a sequence worksheet?

Last Answer : Need Answer

What is the quickest way to remove all the Filters that have been applied to a worksheet and nbsp and nbsp?

Description : What is the quickest way to remove all the Filters that have been applied to a worksheet and nbsp and nbsp?

Last Answer : Need answer