All Categories
Computer Skills
Explore questions in the Computer Skills category that you can ask Spark.E!
- CREATING NEW WORKBOOKS What options exist for creating new workbooks?- Clicking on the plus symbol in the sheet navigation at the bottom of the window - Clicking on the button New Workbook in the Home tab - Clicking on the button Blank workbook in the New section of the Backstage area - Clicking on the button New Workbook in the insert tab
- APPLYING TEXT FILTERS You have many different entries in one of your columns, and you have therefore applied a text filter. What results are displayed?- Entries from the entire workbook- Entries from the worksheet- Entries from the column
- Which formula am I going to use if I want to check if cell A1 contains no value ?
- If i plan to automatically highlight all the row in the range A1:D100 for which the value in column D is less than 100, which formula am I going to state when implementing my conditional format ?
- DATA BARS What are data bars?- A rule for conditional formatting - Number values in cells are additionally depicted visually with bars - A char type in Excel that can be created from the group Charts in the Insert tab
- What is the maximum number of rows for an Excel 365 worksheet ?
- Which character(s) can't be used in a worksheet's name ?There are many good answers !
- Which formula am I going yo put in cell D1 if I'm supposed to have the text Yes or no depending on the fact that the three cells A1, B1, C1 are all 0 or not ?
- If I plan to count in the range C1:C100 the number of cells containing the same value as the cellA1, which formula am I going to use ?
- If we call the "lookup value" the value of the key based on which we're searching in the table, when using the Hlookup mode
- If the cell A1 contains "Ten" and the cell B1 contains "Twenty" what am I going to see in cell C1 if the formula in this cell is =A1+B1
- What's the maximum length for the worksheet's name ?
- Assuming that cell A1 contains an integer value we want to display in cell B1the text "Less than )" if A1 < 0the text "equal to 0" if A1 = 0the text "greater than 0" if A1 > 0Which formula are we going to choose ?
- EXPORTING DATA You would like to save your table such that it cab be presented on the Internet. Which file type do you select?- *.txt- *.html- *.hmtl- *.xml- *.xlsx
- We assume that- column A contains on the lines 1 to 100 the gender for students (a value that may be "F" or "M"),- column B contains on the lines 1 to 100 some values between 0 and 100Which formula am I going to use in cell C1 if I want to add all the values in the range B1:B100 all the values being above 50 and corresponding to female students?
- What's the maximum number of columns for an Excel 365 worksheet ?
- If I want to find the smallest value being above 3000 in the range B1:C200 what will I do ?
- If I want to know how many numbers we have in the range A2:A30 which formula am i going to use ?
- If I want to put in cell C1 the text "Ok" if cell B1 and A1 are both different from 0 or the text "Not ok" if at least one is 0, which formula am I going to pick? Be careful because you may have many good answers!
- If I want to calculate the sum of all the values in the range C1:C100 being between 0 and 100 which formula am i supposed to use?